Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 171150 |
| Missing cells | 8287 |
| Missing cells (%) | 0.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 34.0 MiB |
| Average record size in memory | 208.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Text | 12 |
| Unsupported | 3 |
| Categorical | 2 |
| DateTime | 3 |
ACCESSORIAL_AMOUNT is highly overall correlated with AMOUNT_PAID | High correlation |
AMOUNT_PAID is highly overall correlated with ACCESSORIAL_AMOUNT | High correlation |
IO_CODE is highly overall correlated with Unnamed: 0 | High correlation |
Unnamed: 0 is highly overall correlated with IO_CODE | High correlation |
DESTINATION_COUNTRY_CODE has 1954 (1.1%) missing values | Missing |
ORIGIN_STATE has 3125 (1.8%) missing values | Missing |
ACCESSORIAL_AMOUNT is highly skewed (γ1 = 58.23637883) | Skewed |
AMOUNT_PAID is highly skewed (γ1 = 39.80553388) | Skewed |
SHIP_WEIGHT is highly skewed (γ1 = 34.1117575) | Skewed |
Unnamed: 0 is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
DESTINATION_CITY is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
DESTINATION_ZIP is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ORIGIN_ZIP is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
ACCESSORIAL_AMOUNT has 15279 (8.9%) zeros | Zeros |
MILEAGE has 37398 (21.9%) zeros | Zeros |
SHIP_WEIGHT has 19900 (11.6%) zeros | Zeros |
Reproduction
| Analysis started | 2024-02-16 07:11:30.939693 |
|---|---|
| Analysis finished | 2024-02-16 07:11:49.965448 |
| Duration | 19.03 seconds |
| Software version | ydata-profiling vv4.6.4 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
HIGH CORRELATION  UNIFORM  UNIQUE 
| Distinct | 171150 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 85574.5 |
| Minimum | 0 |
|---|---|
| Maximum | 171149 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8557.45 |
| Q1 | 42787.25 |
| median | 85574.5 |
| Q3 | 128361.75 |
| 95-th percentile | 162591.55 |
| Maximum | 171149 |
| Range | 171149 |
| Interquartile range (IQR) | 85574.5 |
Descriptive statistics
| Standard deviation | 49406.894 |
|---|---|
| Coefficient of variation (CV) | 0.57735533 |
| Kurtosis | -1.2 |
| Mean | 85574.5 |
| Median Absolute Deviation (MAD) | 42787.5 |
| Skewness | 0 |
| Sum | 1.4646076 × 1010 |
| Variance | 2.4410411 × 109 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 114093 | 1 | < 0.1% |
| 114095 | 1 | < 0.1% |
| 114096 | 1 | < 0.1% |
| 114097 | 1 | < 0.1% |
| 114098 | 1 | < 0.1% |
| 114099 | 1 | < 0.1% |
| 114100 | 1 | < 0.1% |
| 114101 | 1 | < 0.1% |
| 114102 | 1 | < 0.1% |
| Other values (171140) | 171140 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 |
| Value | Count | Frequency (%) |
| 171149 | 1 | |
| 171148 | 1 | |
| 171147 | 1 | |
| 171146 | 1 | |
| 171145 | 1 | |
| 171144 | 1 | |
| 171143 | 1 | |
| 171142 | 1 | |
| 171141 | 1 | |
| 171140 | 1 |
ACCESSORIAL_AMOUNT
Real number (ℝ)
HIGH CORRELATION  SKEWED  ZEROS 
| Distinct | 41990 |
|---|---|
| Distinct (%) | 24.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 768.96844 |
| Minimum | 0 |
|---|---|
| Maximum | 896151.99 |
| Zeros | 15279 |
| Zeros (%) | 8.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 21.07656 |
| median | 57.99996 |
| Q3 | 286.33374 |
| 95-th percentile | 2509.6217 |
| Maximum | 896151.99 |
| Range | 896151.99 |
| Interquartile range (IQR) | 265.25718 |
Descriptive statistics
| Standard deviation | 6680.9729 |
|---|---|
| Coefficient of variation (CV) | 8.6882277 |
| Kurtosis | 5461.2501 |
| Mean | 768.96844 |
| Median Absolute Deviation (MAD) | 46.8441 |
| Skewness | 58.236379 |
| Sum | 1.3160895 × 108 |
| Variance | 44635398 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 15279 | 8.9% |
| 68.328 | 2037 | 1.2% |
| 91.98 | 1352 | 0.8% |
| 51.7716 | 819 | 0.5% |
| 65.7 | 705 | 0.4% |
| 328.5 | 385 | 0.2% |
| 131.4 | 373 | 0.2% |
| 64.55682 | 362 | 0.2% |
| 459.9 | 355 | 0.2% |
| 19.71 | 342 | 0.2% |
| Other values (41980) | 149141 |
| Value | Count | Frequency (%) |
| 0 | 15279 | |
| 0.01314 | 2 | < 0.1% |
| 0.07884 | 1 | < 0.1% |
| 1.0512 | 1 | < 0.1% |
| 1.15632 | 1 | < 0.1% |
| 1.26144 | 3 | < 0.1% |
| 1.314 | 2 | < 0.1% |
| 1.52424 | 1 | < 0.1% |
| 1.53738 | 1 | < 0.1% |
| 1.5768 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 896151.9946 | 1 | |
| 846140.4319 | 1 | |
| 655493.9589 | 1 | |
| 592760.6161 | 1 | |
| 563688.5107 | 1 | |
| 533514.695 | 1 | |
| 448882.9772 | 1 | |
| 419682.4677 | 1 | |
| 392183.01 | 1 | |
| 353885.4945 | 1 |
AMOUNT_PAID
Real number (ℝ)
HIGH CORRELATION  SKEWED 
| Distinct | 66507 |
|---|---|
| Distinct (%) | 38.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2234.2118 |
| Minimum | -182.33064 |
|---|---|
| Maximum | 1248300 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 2 |
| Negative (%) | < 0.1% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | -182.33064 |
|---|---|
| 5-th percentile | 100.3239 |
| Q1 | 169.12494 |
| median | 394.24599 |
| Q3 | 1553.3845 |
| 95-th percentile | 7667.2695 |
| Maximum | 1248300 |
| Range | 1248482.3 |
| Interquartile range (IQR) | 1384.2596 |
Descriptive statistics
| Standard deviation | 12427.793 |
|---|---|
| Coefficient of variation (CV) | 5.5624952 |
| Kurtosis | 2464.4414 |
| Mean | 2234.2118 |
| Median Absolute Deviation (MAD) | 277.08318 |
| Skewness | 39.805534 |
| Sum | 3.8238536 × 108 |
| Variance | 1.5445003 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 91.98 | 1329 | 0.8% |
| 51.7716 | 816 | 0.5% |
| 1859.31 | 564 | 0.3% |
| 65.7 | 544 | 0.3% |
| 2168.1 | 488 | 0.3% |
| 657 | 382 | 0.2% |
| 64.55682 | 360 | 0.2% |
| 854.1 | 322 | 0.2% |
| 96.40818 | 321 | 0.2% |
| 96.579 | 289 | 0.2% |
| Other values (66497) | 165735 |
| Value | Count | Frequency (%) |
| -182.33064 | 1 | < 0.1% |
| -20.31444 | 1 | < 0.1% |
| 0.01314 | 1 | < 0.1% |
| 0.07884 | 1 | < 0.1% |
| 1.314 | 3 | |
| 1.39284 | 2 | |
| 1.49796 | 1 | < 0.1% |
| 1.53738 | 1 | < 0.1% |
| 1.74762 | 1 | < 0.1% |
| 1.7739 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1248300 | 1 | < 0.1% |
| 1069405.47 | 1 | < 0.1% |
| 934680.958 | 1 | < 0.1% |
| 896151.9946 | 1 | < 0.1% |
| 846140.4319 | 1 | < 0.1% |
| 802120.1836 | 1 | < 0.1% |
| 770943.51 | 5 | |
| 700061.1071 | 1 | < 0.1% |
| 657000 | 4 | |
| 655493.9589 | 1 | < 0.1% |
CARRIER_NAME2
Text
| Distinct | 88 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
Length
| Max length | 31 |
|---|---|
| Median length | 29 |
| Mean length | 20.21303 |
| Min length | 7 |
Characters and Unicode
| Total characters | 3459460 |
|---|---|
| Distinct characters | 51 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Hodges, Lyons and Weaver |
|---|---|
| 2nd row | Hodges, Lyons and Weaver |
| 3rd row | Hodges, Lyons and Weaver |
| 4th row | Hodges, Lyons and Weaver |
| 5th row | Hodges, Lyons and Weaver |
| Value | Count | Frequency (%) |
| and | 110852 | |
| hodges | 58917 | |
| weaver | 58917 | |
| lyons | 58917 | |
| brown | 16042 | 3.1% |
| duffy | 15782 | 3.0% |
| singh | 15782 | 3.0% |
| anderson-esparza | 15438 | 3.0% |
| foster | 14862 | 2.8% |
| peterson | 14862 | 2.8% |
| Other values (128) | 141230 |
Most occurring characters
| Value | Count | Frequency (%) |
| 350451 | 10.1% | |
| e | 337300 | 9.8% |
| n | 319555 | 9.2% |
| a | 275899 | 8.0% |
| o | 267911 | 7.7% |
| s | 231039 | 6.7% |
| r | 230344 | 6.7% |
| d | 209604 | 6.1% |
| , | 110634 | 3.2% |
| y | 92755 | 2.7% |
| Other values (41) | 1033968 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 2499102 | |
| Uppercase Letter | 457088 | 13.2% |
| Space Separator | 350451 | 10.1% |
| Other Punctuation | 110634 | 3.2% |
| Dash Punctuation | 42185 | 1.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 337300 | |
| n | 319555 | |
| a | 275899 | |
| o | 267911 | |
| s | 231039 | |
| r | 230344 | |
| d | 209604 | |
| y | 92755 | 3.7% |
| g | 89799 | 3.6% |
| v | 58994 | 2.4% |
| Other values (16) | 385902 |
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 87463 | |
| W | 68000 | |
| H | 64344 | |
| P | 27497 | 6.0% |
| B | 22674 | 5.0% |
| T | 22088 | 4.8% |
| A | 20627 | 4.5% |
| D | 18660 | 4.1% |
| E | 18286 | 4.0% |
| I | 16749 | 3.7% |
| Other values (12) | 90700 |
Space Separator
| Value | Count | Frequency (%) |
| 350451 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 110634 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 42185 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2956190 | |
| Common | 503270 | 14.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 337300 | |
| n | 319555 | 10.8% |
| a | 275899 | 9.3% |
| o | 267911 | 9.1% |
| s | 231039 | 7.8% |
| r | 230344 | 7.8% |
| d | 209604 | 7.1% |
| y | 92755 | 3.1% |
| g | 89799 | 3.0% |
| L | 87463 | 3.0% |
| Other values (38) | 814521 |
Common
| Value | Count | Frequency (%) |
| 350451 | ||
| , | 110634 | 22.0% |
| - | 42185 | 8.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3459460 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 350451 | 10.1% | |
| e | 337300 | 9.8% |
| n | 319555 | 9.2% |
| a | 275899 | 8.0% |
| o | 267911 | 7.7% |
| s | 231039 | 6.7% |
| r | 230344 | 6.7% |
| d | 209604 | 6.1% |
| , | 110634 | 3.2% |
| y | 92755 | 2.7% |
| Other values (41) | 1033968 |
DESTINATION_CITY
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 191 |
|---|---|
| Missing (%) | 0.1% |
| Memory size | 1.3 MiB |
| Distinct | 2479 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
Length
| Max length | 24 |
|---|---|
| Median length | 23 |
| Mean length | 12.299112 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2104993 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 8 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 775 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | FAIRBURN, GA |
|---|---|
| 2nd row | FAIRBURN, GA |
| 3rd row | FAIRBURN, GA |
| 4th row | FAIRBURN, GA |
| 5th row | FAIRBURN, GA |
| Value | Count | Frequency (%) |
| ca | 78949 | |
| san | 58387 | |
| diego | 57713 | |
| tx | 38537 | 9.2% |
| ga | 16070 | 3.8% |
| fairburn | 14308 | 3.4% |
| xx | 12997 | 3.1% |
| desoto | 12561 | 3.0% |
| mabank | 8123 | 1.9% |
| houston | 6519 | 1.6% |
| Other values (2339) | 114055 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 257755 | |
| 247117 | ||
| , | 171152 | 8.1% |
| O | 159409 | 7.6% |
| N | 152881 | 7.3% |
| E | 139652 | 6.6% |
| I | 108184 | 5.1% |
| S | 102105 | 4.9% |
| C | 99398 | 4.7% |
| G | 93837 | 4.5% |
| Other values (28) | 573503 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1686681 | |
| Space Separator | 247117 | 11.7% |
| Other Punctuation | 171153 | 8.1% |
| Open Punctuation | 13 | < 0.1% |
| Decimal Number | 11 | < 0.1% |
| Currency Symbol | 9 | < 0.1% |
| Dash Punctuation | 8 | < 0.1% |
| Close Punctuation | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 257755 | |
| O | 159409 | 9.5% |
| N | 152881 | 9.1% |
| E | 139652 | 8.3% |
| I | 108184 | 6.4% |
| S | 102105 | 6.1% |
| C | 99398 | 5.9% |
| G | 93837 | 5.6% |
| D | 88078 | 5.2% |
| T | 85549 | 5.1% |
| Other values (16) | 399833 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 4 | |
| 9 | 3 | |
| 7 | 2 | |
| 1 | 1 | 9.1% |
| 5 | 1 | 9.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 171152 | |
| . | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 247117 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 13 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 9 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 8 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1686681 | |
| Common | 418312 | 19.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 257755 | |
| O | 159409 | 9.5% |
| N | 152881 | 9.1% |
| E | 139652 | 8.3% |
| I | 108184 | 6.4% |
| S | 102105 | 6.1% |
| C | 99398 | 5.9% |
| G | 93837 | 5.6% |
| D | 88078 | 5.2% |
| T | 85549 | 5.1% |
| Other values (16) | 399833 |
Common
| Value | Count | Frequency (%) |
| 247117 | ||
| , | 171152 | |
| ( | 13 | < 0.1% |
| $ | 9 | < 0.1% |
| - | 8 | < 0.1% |
| 0 | 4 | < 0.1% |
| 9 | 3 | < 0.1% |
| 7 | 2 | < 0.1% |
| ) | 1 | < 0.1% |
| 1 | 1 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2104993 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 257755 | |
| 247117 | ||
| , | 171152 | 8.1% |
| O | 159409 | 7.6% |
| N | 152881 | 7.3% |
| E | 139652 | 6.6% |
| I | 108184 | 5.1% |
| S | 102105 | 4.9% |
| C | 99398 | 4.7% |
| G | 93837 | 4.5% |
| Other values (28) | 573503 |
MISSING 
| Distinct | 98 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1954 |
| Missing (%) | 1.1% |
| Memory size | 1.3 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 338392 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 12 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
| Value | Count | Frequency (%) |
| us | 154817 | |
| cz | 6576 | 3.9% |
| be | 2032 | 1.2% |
| au | 1453 | 0.9% |
| ca | 638 | 0.4% |
| de | 623 | 0.4% |
| cn | 410 | 0.2% |
| gb | 394 | 0.2% |
| uk | 195 | 0.1% |
| mx | 163 | 0.1% |
| Other values (88) | 1895 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| U | 156541 | |
| S | 155005 | |
| C | 7737 | 2.3% |
| Z | 6763 | 2.0% |
| E | 2883 | 0.9% |
| B | 2513 | 0.7% |
| A | 2250 | 0.7% |
| D | 851 | 0.3% |
| G | 684 | 0.2% |
| N | 652 | 0.2% |
| Other values (16) | 2513 | 0.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 338392 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| U | 156541 | |
| S | 155005 | |
| C | 7737 | 2.3% |
| Z | 6763 | 2.0% |
| E | 2883 | 0.9% |
| B | 2513 | 0.7% |
| A | 2250 | 0.7% |
| D | 851 | 0.3% |
| G | 684 | 0.2% |
| N | 652 | 0.2% |
| Other values (16) | 2513 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 338392 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| U | 156541 | |
| S | 155005 | |
| C | 7737 | 2.3% |
| Z | 6763 | 2.0% |
| E | 2883 | 0.9% |
| B | 2513 | 0.7% |
| A | 2250 | 0.7% |
| D | 851 | 0.3% |
| G | 684 | 0.2% |
| N | 652 | 0.2% |
| Other values (16) | 2513 | 0.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 338392 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| U | 156541 | |
| S | 155005 | |
| C | 7737 | 2.3% |
| Z | 6763 | 2.0% |
| E | 2883 | 0.9% |
| B | 2513 | 0.7% |
| A | 2250 | 0.7% |
| D | 851 | 0.3% |
| G | 684 | 0.2% |
| N | 652 | 0.2% |
| Other values (16) | 2513 | 0.7% |
| Distinct | 5611 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 191 |
| Missing (%) | 0.1% |
| Memory size | 1.3 MiB |
Length
| Max length | 25 |
|---|---|
| Median length | 23 |
| Mean length | 13.572354 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2320316 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2927 ? |
|---|---|
| Unique (%) | 1.7% |
Sample
| 1st row | Michael Clark |
|---|---|
| 2nd row | Michael Clark |
| 3rd row | Michael Clark |
| 4th row | Michael Clark |
| 5th row | Michael Clark |
| Value | Count | Frequency (%) |
| christopher | 28768 | 8.4% |
| shepard | 27988 | 8.1% |
| brown | 19137 | 5.6% |
| ryan | 18963 | 5.5% |
| ashley | 17966 | 5.2% |
| cruz | 17554 | 5.1% |
| michael | 13222 | 3.8% |
| clark | 11221 | 3.3% |
| carl | 9452 | 2.7% |
| ramsey | 9430 | 2.7% |
| Other values (1478) | 170234 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 207012 | 8.9% |
| e | 204964 | 8.8% |
| a | 175021 | 7.5% |
| 172976 | 7.5% | |
| h | 156406 | 6.7% |
| i | 128861 | 5.6% |
| l | 126649 | 5.5% |
| n | 117738 | 5.1% |
| o | 112085 | 4.8% |
| s | 102777 | 4.4% |
| Other values (44) | 815827 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1800902 | |
| Uppercase Letter | 345618 | 14.9% |
| Space Separator | 172976 | 7.5% |
| Other Punctuation | 820 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 207012 | |
| e | 204964 | |
| a | 175021 | |
| h | 156406 | |
| i | 128861 | 7.2% |
| l | 126649 | 7.0% |
| n | 117738 | 6.5% |
| o | 112085 | 6.2% |
| s | 102777 | 5.7% |
| y | 86339 | 4.8% |
| Other values (16) | 383050 |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 82345 | |
| R | 41890 | |
| S | 39509 | |
| M | 26218 | 7.6% |
| A | 24922 | 7.2% |
| B | 24016 | 6.9% |
| J | 14843 | 4.3% |
| T | 13127 | 3.8% |
| D | 11513 | 3.3% |
| P | 9370 | 2.7% |
| Other values (16) | 57865 |
Space Separator
| Value | Count | Frequency (%) |
| 172976 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 820 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2146520 | |
| Common | 173796 | 7.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 207012 | 9.6% |
| e | 204964 | 9.5% |
| a | 175021 | 8.2% |
| h | 156406 | 7.3% |
| i | 128861 | 6.0% |
| l | 126649 | 5.9% |
| n | 117738 | 5.5% |
| o | 112085 | 5.2% |
| s | 102777 | 4.8% |
| y | 86339 | 4.0% |
| Other values (42) | 728668 |
Common
| Value | Count | Frequency (%) |
| 172976 | ||
| . | 820 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2320316 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 207012 | 8.9% |
| e | 204964 | 8.8% |
| a | 175021 | 7.5% |
| 172976 | 7.5% | |
| h | 156406 | 6.7% |
| i | 128861 | 5.6% |
| l | 126649 | 5.5% |
| n | 117738 | 5.1% |
| o | 112085 | 4.8% |
| s | 102777 | 4.4% |
| Other values (44) | 815827 |
| Distinct | 113 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 989 |
| Missing (%) | 0.6% |
| Memory size | 1.3 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.9999941 |
| Min length | 1 |
Characters and Unicode
| Total characters | 340321 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 15 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | GA |
|---|---|
| 2nd row | GA |
| 3rd row | GA |
| 4th row | GA |
| 5th row | GA |
| Value | Count | Frequency (%) |
| ca | 78946 | |
| tx | 38537 | |
| ga | 16070 | 9.4% |
| xx | 12997 | 7.6% |
| ok | 4078 | 2.4% |
| la | 3216 | 1.9% |
| az | 2229 | 1.3% |
| pa | 984 | 0.6% |
| il | 970 | 0.6% |
| cz | 919 | 0.5% |
| Other values (103) | 11215 | 6.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 103032 | |
| C | 81360 | |
| X | 64590 | |
| T | 39393 | 11.6% |
| G | 16146 | 4.7% |
| O | 5996 | 1.8% |
| L | 4815 | 1.4% |
| K | 4717 | 1.4% |
| Z | 3159 | 0.9% |
| N | 2789 | 0.8% |
| Other values (17) | 14324 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 340312 | |
| Currency Symbol | 9 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 103032 | |
| C | 81360 | |
| X | 64590 | |
| T | 39393 | 11.6% |
| G | 16146 | 4.7% |
| O | 5996 | 1.8% |
| L | 4815 | 1.4% |
| K | 4717 | 1.4% |
| Z | 3159 | 0.9% |
| N | 2789 | 0.8% |
| Other values (16) | 14315 | 4.2% |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 9 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 340312 | |
| Common | 9 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 103032 | |
| C | 81360 | |
| X | 64590 | |
| T | 39393 | 11.6% |
| G | 16146 | 4.7% |
| O | 5996 | 1.8% |
| L | 4815 | 1.4% |
| K | 4717 | 1.4% |
| Z | 3159 | 0.9% |
| N | 2789 | 0.8% |
| Other values (16) | 14315 | 4.2% |
Common
| Value | Count | Frequency (%) |
| $ | 9 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 340321 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 103032 | |
| C | 81360 | |
| X | 64590 | |
| T | 39393 | 11.6% |
| G | 16146 | 4.7% |
| O | 5996 | 1.8% |
| L | 4815 | 1.4% |
| K | 4717 | 1.4% |
| Z | 3159 | 0.9% |
| N | 2789 | 0.8% |
| Other values (17) | 14324 | 4.2% |
DESTINATION_ZIP
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 299 |
|---|---|
| Missing (%) | 0.2% |
| Memory size | 1.3 MiB |
IO_CODE
Categorical
HIGH CORRELATION 
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| 1 | |
|---|---|
| 2 | |
| 4 | |
| 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 171150 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 74578 | |
| 2 | 50690 | |
| 4 | 31528 | |
| 3 | 14354 | 8.4% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 74578 | |
| 2 | 50690 | |
| 4 | 31528 | |
| 3 | 14354 | 8.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 74578 | |
| 2 | 50690 | |
| 4 | 31528 | |
| 3 | 14354 | 8.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 171150 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 74578 | |
| 2 | 50690 | |
| 4 | 31528 | |
| 3 | 14354 | 8.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 171150 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 74578 | |
| 2 | 50690 | |
| 4 | 31528 | |
| 3 | 14354 | 8.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 171150 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 74578 | |
| 2 | 50690 | |
| 4 | 31528 | |
| 3 | 14354 | 8.4% |
MILEAGE
Real number (ℝ)
ZEROS 
| Distinct | 2609 |
|---|---|
| Distinct (%) | 1.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 854.657 |
| Minimum | 0 |
|---|---|
| Maximum | 4814 |
| Zeros | 37398 |
| Zeros (%) | 21.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 15 |
| median | 663 |
| Q3 | 1448 |
| 95-th percentile | 2398 |
| Maximum | 4814 |
| Range | 4814 |
| Interquartile range (IQR) | 1433 |
Descriptive statistics
| Standard deviation | 873.58099 |
|---|---|
| Coefficient of variation (CV) | 1.0221422 |
| Kurtosis | -0.69947766 |
| Mean | 854.657 |
| Median Absolute Deviation (MAD) | 663 |
| Skewness | 0.68954862 |
| Sum | 1.4627455 × 108 |
| Variance | 763143.75 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37398 | 21.9% |
| 1345 | 4034 | 2.4% |
| 2118 | 2720 | 1.6% |
| 117 | 2380 | 1.4% |
| 15 | 2245 | 1.3% |
| 1462 | 2142 | 1.3% |
| 1024 | 2131 | 1.2% |
| 1392 | 2029 | 1.2% |
| 352 | 1933 | 1.1% |
| 1102 | 1839 | 1.1% |
| Other values (2599) | 112299 |
| Value | Count | Frequency (%) |
| 0 | 37398 | |
| 2 | 3 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 963 | 0.6% |
| 5 | 7 | < 0.1% |
| 6 | 81 | < 0.1% |
| 7 | 57 | < 0.1% |
| 8 | 361 | 0.2% |
| 9 | 1592 | 0.9% |
| 10 | 668 | 0.4% |
| Value | Count | Frequency (%) |
| 4814 | 1 | < 0.1% |
| 4653 | 1 | < 0.1% |
| 4651 | 6 | |
| 4541 | 1 | < 0.1% |
| 4432 | 1 | < 0.1% |
| 4418 | 4 | |
| 4394 | 1 | < 0.1% |
| 4359 | 2 | < 0.1% |
| 4332 | 1 | < 0.1% |
| 4327 | 6 |
ORIGIN_CITY
Text
| Distinct | 2105 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 18 |
| Mean length | 8.3372714 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1426924 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 675 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | LAS VEGAS |
|---|---|
| 2nd row | LAS VEGAS |
| 3rd row | HIDALGO |
| 4th row | SAN DIEGO |
| 5th row | CHULA VISTA |
| Value | Count | Frequency (%) |
| san | 28630 | 12.6% |
| diego | 27461 | 12.1% |
| fairburn | 17126 | 7.5% |
| desoto | 11419 | 5.0% |
| tijuana | 6774 | 3.0% |
| houston | 5583 | 2.5% |
| mabank | 5107 | 2.2% |
| south | 4681 | 2.1% |
| gate | 4307 | 1.9% |
| ontario | 4190 | 1.8% |
| Other values (2139) | 111778 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 162943 | |
| N | 148910 | 10.4% |
| O | 144979 | 10.2% |
| E | 123738 | 8.7% |
| I | 102014 | 7.1% |
| R | 95484 | 6.7% |
| S | 84634 | 5.9% |
| T | 69532 | 4.9% |
| D | 62886 | 4.4% |
| 56111 | 3.9% | |
| Other values (29) | 375693 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1370607 | |
| Space Separator | 56111 | 3.9% |
| Decimal Number | 85 | < 0.1% |
| Dash Punctuation | 65 | < 0.1% |
| Other Punctuation | 29 | < 0.1% |
| Open Punctuation | 25 | < 0.1% |
| Close Punctuation | 2 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 162943 | |
| N | 148910 | |
| O | 144979 | |
| E | 123738 | 9.0% |
| I | 102014 | 7.4% |
| R | 95484 | 7.0% |
| S | 84634 | 6.2% |
| T | 69532 | 5.1% |
| D | 62886 | 4.6% |
| G | 53182 | 3.9% |
| Other values (16) | 322305 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 34 | |
| 0 | 20 | |
| 3 | 15 | |
| 2 | 14 | |
| 6 | 2 | 2.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 17 | |
| , | 5 | 17.2% |
| . | 5 | 17.2% |
| " | 2 | 6.9% |
Space Separator
| Value | Count | Frequency (%) |
| 56111 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 65 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 25 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1370607 | |
| Common | 56317 | 3.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 162943 | |
| N | 148910 | |
| O | 144979 | |
| E | 123738 | 9.0% |
| I | 102014 | 7.4% |
| R | 95484 | 7.0% |
| S | 84634 | 6.2% |
| T | 69532 | 5.1% |
| D | 62886 | 4.6% |
| G | 53182 | 3.9% |
| Other values (16) | 322305 |
Common
| Value | Count | Frequency (%) |
| 56111 | ||
| - | 65 | 0.1% |
| 1 | 34 | 0.1% |
| ( | 25 | < 0.1% |
| 0 | 20 | < 0.1% |
| / | 17 | < 0.1% |
| 3 | 15 | < 0.1% |
| 2 | 14 | < 0.1% |
| , | 5 | < 0.1% |
| . | 5 | < 0.1% |
| Other values (3) | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1426924 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 162943 | |
| N | 148910 | 10.4% |
| O | 144979 | 10.2% |
| E | 123738 | 8.7% |
| I | 102014 | 7.1% |
| R | 95484 | 6.7% |
| S | 84634 | 5.9% |
| T | 69532 | 4.9% |
| D | 62886 | 4.4% |
| 56111 | 3.9% | |
| Other values (29) | 375693 |
| Distinct | 2445 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
Length
| Max length | 24 |
|---|---|
| Median length | 22 |
| Mean length | 12.282495 |
| Min length | 5 |
Characters and Unicode
| Total characters | 2102149 |
|---|---|
| Distinct characters | 39 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 867 ? |
|---|---|
| Unique (%) | 0.5% |
Sample
| 1st row | LAS VEGAS, NV |
|---|---|
| 2nd row | LAS VEGAS, NV |
| 3rd row | HIDALGO, TX |
| 4th row | SAN DIEGO, CA |
| 5th row | CHULA VISTA, CA |
| Value | Count | Frequency (%) |
| ca | 58498 | 14.8% |
| tx | 33152 | 8.4% |
| san | 28630 | 7.2% |
| diego | 27461 | 7.0% |
| ga | 20674 | 5.2% |
| fairburn | 17126 | 4.3% |
| desoto | 11419 | 2.9% |
| tijuana | 6774 | 1.7% |
| houston | 5583 | 1.4% |
| mabank | 5107 | 1.3% |
| Other values (2222) | 180657 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 253114 | |
| 224136 | 10.7% | |
| , | 171155 | 8.1% |
| N | 159144 | 7.6% |
| O | 158202 | 7.5% |
| E | 124603 | 5.9% |
| I | 109001 | 5.2% |
| T | 105151 | 5.0% |
| R | 96947 | 4.6% |
| C | 92659 | 4.4% |
| Other values (29) | 608037 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1706657 | |
| Space Separator | 224136 | 10.7% |
| Other Punctuation | 171179 | 8.1% |
| Decimal Number | 85 | < 0.1% |
| Dash Punctuation | 65 | < 0.1% |
| Open Punctuation | 25 | < 0.1% |
| Close Punctuation | 2 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 253114 | |
| N | 159144 | 9.3% |
| O | 158202 | 9.3% |
| E | 124603 | 7.3% |
| I | 109001 | 6.4% |
| T | 105151 | 6.2% |
| R | 96947 | 5.7% |
| C | 92659 | 5.4% |
| S | 86747 | 5.1% |
| G | 73881 | 4.3% |
| Other values (16) | 447208 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 34 | |
| 0 | 20 | |
| 3 | 15 | |
| 2 | 14 | |
| 6 | 2 | 2.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 171155 | |
| / | 17 | < 0.1% |
| . | 5 | < 0.1% |
| " | 2 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 224136 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 65 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 25 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1706657 | |
| Common | 395492 | 18.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 253114 | |
| N | 159144 | 9.3% |
| O | 158202 | 9.3% |
| E | 124603 | 7.3% |
| I | 109001 | 6.4% |
| T | 105151 | 6.2% |
| R | 96947 | 5.7% |
| C | 92659 | 5.4% |
| S | 86747 | 5.1% |
| G | 73881 | 4.3% |
| Other values (16) | 447208 |
Common
| Value | Count | Frequency (%) |
| 224136 | ||
| , | 171155 | |
| - | 65 | < 0.1% |
| 1 | 34 | < 0.1% |
| ( | 25 | < 0.1% |
| 0 | 20 | < 0.1% |
| / | 17 | < 0.1% |
| 3 | 15 | < 0.1% |
| 2 | 14 | < 0.1% |
| . | 5 | < 0.1% |
| Other values (3) | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2102149 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 253114 | |
| 224136 | 10.7% | |
| , | 171155 | 8.1% |
| N | 159144 | 7.6% |
| O | 158202 | 7.5% |
| E | 124603 | 5.9% |
| I | 109001 | 5.2% |
| T | 105151 | 5.0% |
| R | 96947 | 4.6% |
| C | 92659 | 4.4% |
| Other values (29) | 608037 |
| Distinct | 84 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 926 |
| Missing (%) | 0.5% |
| Memory size | 1.3 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 340448 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | US |
|---|---|
| 2nd row | US |
| 3rd row | US |
| 4th row | US |
| 5th row | US |
| Value | Count | Frequency (%) |
| us | 152327 | |
| mx | 7611 | 4.5% |
| ca | 3832 | 2.3% |
| cz | 1347 | 0.8% |
| de | 483 | 0.3% |
| jp | 477 | 0.3% |
| tr | 455 | 0.3% |
| it | 424 | 0.2% |
| gb | 424 | 0.2% |
| se | 277 | 0.2% |
| Other values (74) | 2567 | 1.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 152749 | |
| U | 152702 | |
| M | 7749 | 2.3% |
| X | 7613 | 2.2% |
| C | 5412 | 1.6% |
| A | 4291 | 1.3% |
| Z | 1353 | 0.4% |
| T | 1180 | 0.3% |
| E | 985 | 0.3% |
| I | 940 | 0.3% |
| Other values (16) | 5474 | 1.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 340448 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 152749 | |
| U | 152702 | |
| M | 7749 | 2.3% |
| X | 7613 | 2.2% |
| C | 5412 | 1.6% |
| A | 4291 | 1.3% |
| Z | 1353 | 0.4% |
| T | 1180 | 0.3% |
| E | 985 | 0.3% |
| I | 940 | 0.3% |
| Other values (16) | 5474 | 1.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 340448 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 152749 | |
| U | 152702 | |
| M | 7749 | 2.3% |
| X | 7613 | 2.2% |
| C | 5412 | 1.6% |
| A | 4291 | 1.3% |
| Z | 1353 | 0.4% |
| T | 1180 | 0.3% |
| E | 985 | 0.3% |
| I | 940 | 0.3% |
| Other values (16) | 5474 | 1.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 340448 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 152749 | |
| U | 152702 | |
| M | 7749 | 2.3% |
| X | 7613 | 2.2% |
| C | 5412 | 1.6% |
| A | 4291 | 1.3% |
| Z | 1353 | 0.4% |
| T | 1180 | 0.3% |
| E | 985 | 0.3% |
| I | 940 | 0.3% |
| Other values (16) | 5474 | 1.6% |
ORIGIN_NAME2
Text
| Distinct | 5609 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 1.3 MiB |
Length
| Max length | 28 |
|---|---|
| Median length | 24 |
| Mean length | 13.068402 |
| Min length | 7 |
Characters and Unicode
| Total characters | 2236644 |
|---|---|
| Distinct characters | 54 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2801 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | Melissa Bowen |
|---|---|
| 2nd row | Melissa Bowen |
| 3rd row | Dana Hancock |
| 4th row | Ashley Rocha |
| 5th row | Jessica Huang |
| Value | Count | Frequency (%) |
| nguyen | 16564 | 4.8% |
| kristie | 16504 | 4.8% |
| sanchez | 11141 | 3.2% |
| roy | 11113 | 3.2% |
| gregory | 9930 | 2.9% |
| avery | 9687 | 2.8% |
| scott | 8135 | 2.3% |
| larsen | 6676 | 1.9% |
| hailey | 6674 | 1.9% |
| angela | 6047 | 1.7% |
| Other values (1481) | 244564 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 224761 | 10.0% |
| 175886 | 7.9% | |
| r | 171547 | 7.7% |
| a | 169884 | 7.6% |
| n | 157454 | 7.0% |
| i | 135040 | 6.0% |
| o | 120240 | 5.4% |
| l | 95353 | 4.3% |
| s | 94896 | 4.2% |
| y | 92132 | 4.1% |
| Other values (44) | 799451 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1708226 | |
| Uppercase Letter | 350489 | 15.7% |
| Space Separator | 175886 | 7.9% |
| Other Punctuation | 2043 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 224761 | |
| r | 171547 | |
| a | 169884 | |
| n | 157454 | |
| i | 135040 | 7.9% |
| o | 120240 | 7.0% |
| l | 95353 | 5.6% |
| s | 94896 | 5.6% |
| y | 92132 | 5.4% |
| t | 87530 | 5.1% |
| Other values (16) | 359389 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 37826 | 10.8% |
| A | 32219 | 9.2% |
| C | 25359 | 7.2% |
| K | 23953 | 6.8% |
| R | 23335 | 6.7% |
| M | 22526 | 6.4% |
| N | 21838 | 6.2% |
| L | 20125 | 5.7% |
| H | 18354 | 5.2% |
| B | 17074 | 4.9% |
| Other values (16) | 107880 |
Space Separator
| Value | Count | Frequency (%) |
| 175886 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 2043 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2058715 | |
| Common | 177929 | 8.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 224761 | 10.9% |
| r | 171547 | 8.3% |
| a | 169884 | 8.3% |
| n | 157454 | 7.6% |
| i | 135040 | 6.6% |
| o | 120240 | 5.8% |
| l | 95353 | 4.6% |
| s | 94896 | 4.6% |
| y | 92132 | 4.5% |
| t | 87530 | 4.3% |
| Other values (42) | 709878 |
Common
| Value | Count | Frequency (%) |
| 175886 | ||
| . | 2043 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2236644 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 224761 | 10.0% |
| 175886 | 7.9% | |
| r | 171547 | 7.7% |
| a | 169884 | 7.6% |
| n | 157454 | 7.0% |
| i | 135040 | 6.0% |
| o | 120240 | 5.4% |
| l | 95353 | 4.3% |
| s | 94896 | 4.2% |
| y | 92132 | 4.1% |
| Other values (44) | 799451 |
ORIGIN_STATE
Text
MISSING 
| Distinct | 101 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 3125 |
| Missing (%) | 1.8% |
| Memory size | 1.3 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 336050 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 6 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | NV |
|---|---|
| 2nd row | NV |
| 3rd row | TX |
| 4th row | CA |
| 5th row | CA |
| Value | Count | Frequency (%) |
| ca | 58497 | |
| tx | 33152 | |
| ga | 20674 | 12.3% |
| oh | 4626 | 2.8% |
| xx | 4502 | 2.7% |
| ok | 4401 | 2.6% |
| pa | 3695 | 2.2% |
| bc | 3612 | 2.1% |
| az | 3490 | 2.1% |
| wi | 3270 | 1.9% |
| Other values (91) | 28106 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 90171 | |
| C | 66419 | |
| X | 45302 | |
| T | 35619 | 10.6% |
| G | 20699 | 6.2% |
| O | 13223 | 3.9% |
| N | 10234 | 3.0% |
| M | 8317 | 2.5% |
| I | 6987 | 2.1% |
| K | 6454 | 1.9% |
| Other values (16) | 32625 | 9.7% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 336050 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 90171 | |
| C | 66419 | |
| X | 45302 | |
| T | 35619 | 10.6% |
| G | 20699 | 6.2% |
| O | 13223 | 3.9% |
| N | 10234 | 3.0% |
| M | 8317 | 2.5% |
| I | 6987 | 2.1% |
| K | 6454 | 1.9% |
| Other values (16) | 32625 | 9.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 336050 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 90171 | |
| C | 66419 | |
| X | 45302 | |
| T | 35619 | 10.6% |
| G | 20699 | 6.2% |
| O | 13223 | 3.9% |
| N | 10234 | 3.0% |
| M | 8317 | 2.5% |
| I | 6987 | 2.1% |
| K | 6454 | 1.9% |
| Other values (16) | 32625 | 9.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 336050 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 90171 | |
| C | 66419 | |
| X | 45302 | |
| T | 35619 | 10.6% |
| G | 20699 | 6.2% |
| O | 13223 | 3.9% |
| N | 10234 | 3.0% |
| M | 8317 | 2.5% |
| I | 6987 | 2.1% |
| K | 6454 | 1.9% |
| Other values (16) | 32625 | 9.7% |
ORIGIN_ZIP
Unsupported
REJECTED  UNSUPPORTED 
| Missing | 108 |
|---|---|
| Missing (%) | 0.1% |
| Memory size | 1.3 MiB |
PROCESS_DAY_YEAR
Date
| Distinct | 1045 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Minimum | 2020-01-06 00:00:00 |
|---|---|
| Maximum | 2024-02-06 00:00:00 |
PRO_NUMBER2
Real number (ℝ)
| Distinct | 169730 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.0124493 × 1012 |
| Minimum | 1.2838423 × 108 |
|---|---|
| Maximum | 9.9999377 × 1012 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 1.2838423 × 108 |
|---|---|
| 5-th percentile | 5.0447931 × 1011 |
| Q1 | 2.5139144 × 1012 |
| median | 5.0167654 × 1012 |
| Q3 | 7.5063477 × 1012 |
| 95-th percentile | 9.5077653 × 1012 |
| Maximum | 9.9999377 × 1012 |
| Range | 9.9998093 × 1012 |
| Interquartile range (IQR) | 4.9924333 × 1012 |
Descriptive statistics
| Standard deviation | 2.8867893 × 1012 |
|---|---|
| Coefficient of variation (CV) | 0.57592389 |
| Kurtosis | -1.1981616 |
| Mean | 5.0124493 × 1012 |
| Median Absolute Deviation (MAD) | 2.4965018 × 1012 |
| Skewness | -0.0040224445 |
| Sum | 8.578807 × 1017 |
| Variance | 8.3335526 × 1024 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.345975234 × 1012 | 4 | < 0.1% |
| 2.244318968 × 1012 | 4 | < 0.1% |
| 8.605623023 × 1012 | 3 | < 0.1% |
| 3.145539651 × 1012 | 3 | < 0.1% |
| 1.378475192 × 1011 | 3 | < 0.1% |
| 9.522002647 × 1012 | 3 | < 0.1% |
| 7.666873734 × 1012 | 3 | < 0.1% |
| 7.867134112 × 1011 | 3 | < 0.1% |
| 7.940553501 × 1012 | 3 | < 0.1% |
| 4.22110682 × 1011 | 3 | < 0.1% |
| Other values (169720) | 171118 |
| Value | Count | Frequency (%) |
| 128384228 | 1 | |
| 135149629 | 1 | |
| 169549877 | 1 | |
| 175591785 | 1 | |
| 213976710 | 1 | |
| 402685065 | 1 | |
| 479960157 | 1 | |
| 497546968 | 1 | |
| 523138549 | 1 | |
| 553233603 | 1 |
| Value | Count | Frequency (%) |
| 9.999937663 × 1012 | 1 | |
| 9.999858228 × 1012 | 1 | |
| 9.999853088 × 1012 | 1 | |
| 9.999796206 × 1012 | 1 | |
| 9.999718983 × 1012 | 1 | |
| 9.999698537 × 1012 | 1 | |
| 9.999620617 × 1012 | 1 | |
| 9.999465428 × 1012 | 1 | |
| 9.999380799 × 1012 | 1 | |
| 9.999362346 × 1012 | 1 |
RECEIVER
Text
| Distinct | 5812 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 191 |
| Missing (%) | 0.1% |
| Memory size | 1.3 MiB |
Length
| Max length | 20 |
|---|---|
| Median length | 19 |
| Mean length | 16.219918 |
| Min length | 1 |
Characters and Unicode
| Total characters | 2772941 |
|---|---|
| Distinct characters | 48 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3134 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | SOLAR TURBINES INC |
|---|---|
| 2nd row | SOLAR TURBINES INC |
| 3rd row | SOLAR TURBINES INC |
| 4th row | SOLAR TURBINES INC |
| 5th row | SOLAR TURBINES INC |
| Value | Count | Frequency (%) |
| solar | 97341 | |
| turbines | 94590 | |
| harbo | 18840 | 4.4% |
| kearn | 17833 | 4.2% |
| inc | 13208 | 3.1% |
| overh | 9420 | 2.2% |
| turbotec | 9041 | 2.1% |
| c/o | 7174 | 1.7% |
| ups-scs | 7109 | 1.7% |
| reman | 6052 | 1.4% |
| Other values (4856) | 146133 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 338878 | |
| S | 256446 | |
| 255863 | ||
| A | 217788 | 7.9% |
| E | 210968 | 7.6% |
| O | 205280 | 7.4% |
| N | 179548 | 6.5% |
| I | 169465 | 6.1% |
| T | 162584 | 5.9% |
| L | 143040 | 5.2% |
| Other values (38) | 633081 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2497877 | |
| Space Separator | 255863 | 9.2% |
| Dash Punctuation | 9986 | 0.4% |
| Other Punctuation | 8766 | 0.3% |
| Decimal Number | 442 | < 0.1% |
| Open Punctuation | 6 | < 0.1% |
| Modifier Symbol | 1 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 338878 | |
| S | 256446 | |
| A | 217788 | |
| E | 210968 | |
| O | 205280 | |
| N | 179548 | 7.2% |
| I | 169465 | 6.8% |
| T | 162584 | 6.5% |
| L | 143040 | 5.7% |
| B | 139241 | 5.6% |
| Other values (16) | 474639 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 203 | |
| 3 | 98 | |
| 0 | 42 | 9.5% |
| 1 | 27 | 6.1% |
| 8 | 23 | 5.2% |
| 6 | 20 | 4.5% |
| 4 | 10 | 2.3% |
| 5 | 9 | 2.0% |
| 7 | 6 | 1.4% |
| 9 | 4 | 0.9% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 7569 | |
| & | 572 | 6.5% |
| % | 569 | 6.5% |
| . | 50 | 0.6% |
| ' | 3 | < 0.1% |
| ; | 2 | < 0.1% |
| @ | 1 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 5 | |
| [ | 1 | 16.7% |
Space Separator
| Value | Count | Frequency (%) |
| 255863 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 9986 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2497877 | |
| Common | 275064 | 9.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 338878 | |
| S | 256446 | |
| A | 217788 | |
| E | 210968 | |
| O | 205280 | |
| N | 179548 | 7.2% |
| I | 169465 | 6.8% |
| T | 162584 | 6.5% |
| L | 143040 | 5.7% |
| B | 139241 | 5.6% |
| Other values (16) | 474639 |
Common
| Value | Count | Frequency (%) |
| 255863 | ||
| - | 9986 | 3.6% |
| / | 7569 | 2.8% |
| & | 572 | 0.2% |
| % | 569 | 0.2% |
| 2 | 203 | 0.1% |
| 3 | 98 | < 0.1% |
| . | 50 | < 0.1% |
| 0 | 42 | < 0.1% |
| 1 | 27 | < 0.1% |
| Other values (12) | 85 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2772941 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 338878 | |
| S | 256446 | |
| 255863 | ||
| A | 217788 | 7.9% |
| E | 210968 | 7.6% |
| O | 205280 | 7.4% |
| N | 179548 | 6.5% |
| I | 169465 | 6.1% |
| T | 162584 | 5.9% |
| L | 143040 | 5.2% |
| Other values (38) | 633081 |
SHIPPER
Text
| Distinct | 5828 |
|---|---|
| Distinct (%) | 3.4% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 1.3 MiB |
Length
| Max length | 30 |
|---|---|
| Median length | 28 |
| Mean length | 15.707302 |
| Min length | 2 |
Characters and Unicode
| Total characters | 2688289 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 3031 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | CALTROL INC |
|---|---|
| 2nd row | CALTROL INC |
| 3rd row | AMETEK-PRESTOLI |
| 4th row | REXEL HOLDINGS |
| 5th row | MOTION INDUSTRI |
| Value | Count | Frequency (%) |
| solar | 56207 | 13.6% |
| turbines | 55779 | 13.5% |
| inc | 21801 | 5.3% |
| overhaul | 9685 | 2.3% |
| turbotec | 8916 | 2.2% |
| mesa | 6699 | 1.6% |
| kearny | 6673 | 1.6% |
| chromalloy | 5687 | 1.4% |
| c/o | 5623 | 1.4% |
| ups-scs | 5539 | 1.3% |
| Other values (4892) | 231733 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 277560 | 10.3% |
| 243357 | 9.1% | |
| E | 211734 | 7.9% |
| A | 208665 | 7.8% |
| S | 198820 | 7.4% |
| O | 192331 | 7.2% |
| I | 178820 | 6.7% |
| N | 169526 | 6.3% |
| T | 160962 | 6.0% |
| L | 138895 | 5.2% |
| Other values (50) | 707619 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2426060 | |
| Space Separator | 243357 | 9.1% |
| Other Punctuation | 9202 | 0.3% |
| Dash Punctuation | 9170 | 0.3% |
| Decimal Number | 220 | < 0.1% |
| Lowercase Letter | 198 | < 0.1% |
| Open Punctuation | 42 | < 0.1% |
| Close Punctuation | 38 | < 0.1% |
| Modifier Symbol | 2 | < 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 277560 | |
| E | 211734 | 8.7% |
| A | 208665 | 8.6% |
| S | 198820 | 8.2% |
| O | 192331 | 7.9% |
| I | 178820 | 7.4% |
| N | 169526 | 7.0% |
| T | 160962 | 6.6% |
| L | 138895 | 5.7% |
| U | 122697 | 5.1% |
| Other values (16) | 566050 |
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 28 | |
| a | 28 | |
| n | 28 | |
| l | 16 | |
| j | 14 | |
| o | 14 | |
| c | 14 | |
| m | 14 | |
| d | 14 | |
| r | 14 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 80 | |
| 2 | 39 | |
| 1 | 35 | |
| 3 | 27 | 12.3% |
| 5 | 12 | 5.5% |
| 6 | 8 | 3.6% |
| 9 | 6 | 2.7% |
| 4 | 6 | 2.7% |
| 7 | 4 | 1.8% |
| 8 | 3 | 1.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 7220 | |
| & | 1355 | 14.7% |
| . | 364 | 4.0% |
| % | 250 | 2.7% |
| # | 4 | < 0.1% |
| ' | 4 | < 0.1% |
| ; | 4 | < 0.1% |
| , | 1 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 243357 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 9170 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 42 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 38 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2426258 | |
| Common | 262031 | 9.7% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 277560 | |
| E | 211734 | 8.7% |
| A | 208665 | 8.6% |
| S | 198820 | 8.2% |
| O | 192331 | 7.9% |
| I | 178820 | 7.4% |
| N | 169526 | 7.0% |
| T | 160962 | 6.6% |
| L | 138895 | 5.7% |
| U | 122697 | 5.1% |
| Other values (27) | 566248 |
Common
| Value | Count | Frequency (%) |
| 243357 | ||
| - | 9170 | 3.5% |
| / | 7220 | 2.8% |
| & | 1355 | 0.5% |
| . | 364 | 0.1% |
| % | 250 | 0.1% |
| 0 | 80 | < 0.1% |
| ( | 42 | < 0.1% |
| 2 | 39 | < 0.1% |
| ) | 38 | < 0.1% |
| Other values (13) | 116 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2688289 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 277560 | 10.3% |
| 243357 | 9.1% | |
| E | 211734 | 7.9% |
| A | 208665 | 7.8% |
| S | 198820 | 7.4% |
| O | 192331 | 7.2% |
| I | 178820 | 6.7% |
| N | 169526 | 6.3% |
| T | 160962 | 6.0% |
| L | 138895 | 5.2% |
| Other values (50) | 707619 |
SHIP_DATE
Date
| Distinct | 1476 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Minimum | 2020-01-01 00:00:00 |
|---|---|
| Maximum | 2024-02-02 00:00:00 |
SHIP_DAY_YEAR
Date
| Distinct | 1476 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.3 MiB |
| Minimum | 2020-01-01 00:00:00 |
|---|---|
| Maximum | 2024-02-02 00:00:00 |
SHIP_WEIGHT
Real number (ℝ)
SKEWED  ZEROS 
| Distinct | 14826 |
|---|---|
| Distinct (%) | 8.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3349.3079 |
| Minimum | 0 |
|---|---|
| Maximum | 1421500 |
| Zeros | 19900 |
| Zeros (%) | 11.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 150 |
| median | 465 |
| Q3 | 1672.75 |
| 95-th percentile | 17805.1 |
| Maximum | 1421500 |
| Range | 1421500 |
| Interquartile range (IQR) | 1522.75 |
Descriptive statistics
| Standard deviation | 14571.031 |
|---|---|
| Coefficient of variation (CV) | 4.3504604 |
| Kurtosis | 2230.8997 |
| Mean | 3349.3079 |
| Median Absolute Deviation (MAD) | 459 |
| Skewness | 34.111758 |
| Sum | 5.7323405 × 108 |
| Variance | 2.1231495 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 19900 | 11.6% |
| 1 | 3176 | 1.9% |
| 100 | 1127 | 0.7% |
| 300 | 1100 | 0.6% |
| 200 | 1073 | 0.6% |
| 400 | 965 | 0.6% |
| 150 | 955 | 0.6% |
| 1500 | 915 | 0.5% |
| 500 | 885 | 0.5% |
| 250 | 732 | 0.4% |
| Other values (14816) | 140322 |
| Value | Count | Frequency (%) |
| 0 | 19900 | |
| 1 | 3176 | 1.9% |
| 2 | 313 | 0.2% |
| 2.205 | 468 | 0.3% |
| 3 | 187 | 0.1% |
| 4 | 136 | 0.1% |
| 4.409 | 113 | 0.1% |
| 5 | 164 | 0.1% |
| 6 | 82 | < 0.1% |
| 6.614 | 56 | < 0.1% |
| Value | Count | Frequency (%) |
| 1421500 | 1 | < 0.1% |
| 1178072.905 | 1 | < 0.1% |
| 1158465.326 | 1 | < 0.1% |
| 1158421.234 | 2 | |
| 973639 | 2 | |
| 971503.29 | 3 | |
| 672356.538 | 1 | < 0.1% |
| 663641.813 | 1 | < 0.1% |
| 532968 | 2 | |
| 527277.208 | 1 | < 0.1% |
SOLAR_MODE
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 311 |
| Missing (%) | 0.2% |
| Memory size | 1.3 MiB |
| LTL | |
|---|---|
| TL | |
| AE | |
| FF | 7548 |
| CU | 6377 |
| Other values (7) | 9924 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.6327888 |
| Min length | 2 |
Characters and Unicode
| Total characters | 449783 |
|---|---|
| Distinct characters | 15 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LTL |
|---|---|
| 2nd row | LTL |
| 3rd row | LTL |
| 4th row | LTL |
| 5th row | LTL |
Common Values
| Value | Count | Frequency (%) |
| LTL | 106381 | |
| TL | 23510 | 13.7% |
| AE | 17099 | 10.0% |
| FF | 7548 | 4.4% |
| CU | 6377 | 3.7% |
| HH | 5700 | 3.3% |
| CR | 2016 | 1.2% |
| OCN | 1548 | 0.9% |
| MS | 372 | 0.2% |
| PAR | 176 | 0.1% |
| Other values (2) | 112 | 0.1% |
| (Missing) | 311 | 0.2% |
Length
| Value | Count | Frequency (%) |
| ltl | 106381 | |
| tl | 23510 | 13.8% |
| ae | 17099 | 10.0% |
| ff | 7548 | 4.4% |
| cu | 6377 | 3.7% |
| hh | 5700 | 3.3% |
| cr | 2016 | 1.2% |
| ocn | 1548 | 0.9% |
| ms | 372 | 0.2% |
| par | 176 | 0.1% |
| Other values (2) | 112 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| L | 236272 | |
| T | 129891 | |
| A | 17347 | 3.9% |
| E | 17099 | 3.8% |
| F | 15096 | 3.4% |
| H | 11400 | 2.5% |
| C | 9941 | 2.2% |
| U | 6377 | 1.4% |
| R | 2192 | 0.5% |
| O | 1548 | 0.3% |
| Other values (5) | 2620 | 0.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 449783 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| L | 236272 | |
| T | 129891 | |
| A | 17347 | 3.9% |
| E | 17099 | 3.8% |
| F | 15096 | 3.4% |
| H | 11400 | 2.5% |
| C | 9941 | 2.2% |
| U | 6377 | 1.4% |
| R | 2192 | 0.5% |
| O | 1548 | 0.3% |
| Other values (5) | 2620 | 0.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 449783 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| L | 236272 | |
| T | 129891 | |
| A | 17347 | 3.9% |
| E | 17099 | 3.8% |
| F | 15096 | 3.4% |
| H | 11400 | 2.5% |
| C | 9941 | 2.2% |
| U | 6377 | 1.4% |
| R | 2192 | 0.5% |
| O | 1548 | 0.3% |
| Other values (5) | 2620 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 449783 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| L | 236272 | |
| T | 129891 | |
| A | 17347 | 3.9% |
| E | 17099 | 3.8% |
| F | 15096 | 3.4% |
| H | 11400 | 2.5% |
| C | 9941 | 2.2% |
| U | 6377 | 1.4% |
| R | 2192 | 0.5% |
| O | 1548 | 0.3% |
| Other values (5) | 2620 | 0.6% |
| ACCESSORIAL_AMOUNT | AMOUNT_PAID | IO_CODE | MILEAGE | PRO_NUMBER2 | SHIP_WEIGHT | SOLAR_MODE | Unnamed: 0 | |
|---|---|---|---|---|---|---|---|---|
| ACCESSORIAL_AMOUNT | 1.000 | 0.595 | 0.011 | -0.184 | -0.003 | 0.099 | 0.045 | 0.105 |
| AMOUNT_PAID | 0.595 | 1.000 | 0.017 | -0.013 | -0.003 | 0.413 | 0.046 | 0.149 |
| IO_CODE | 0.011 | 0.017 | 1.000 | -0.081 | -0.004 | 0.017 | 0.311 | 0.880 |
| MILEAGE | -0.184 | -0.013 | -0.081 | 1.000 | 0.006 | 0.293 | 0.147 | -0.085 |
| PRO_NUMBER2 | -0.003 | -0.003 | -0.004 | 0.006 | 1.000 | 0.000 | 0.000 | -0.003 |
| SHIP_WEIGHT | 0.099 | 0.413 | 0.017 | 0.293 | 0.000 | 1.000 | 0.060 | 0.033 |
| SOLAR_MODE | 0.045 | 0.046 | 0.311 | 0.147 | 0.000 | 0.060 | 1.000 | 0.039 |
| Unnamed: 0 | 0.105 | 0.149 | 0.880 | -0.085 | -0.003 | 0.033 | 0.039 | 1.000 |
| Unnamed: 0 | ACCESSORIAL_AMOUNT | AMOUNT_PAID | CARRIER_NAME2 | DESTINATION_CITY | DESTINATION_CITY_STATE | DESTINATION_COUNTRY_CODE | DESTINATION_NAME2 | DESTINATION_STATE | DESTINATION_ZIP | IO_CODE | MILEAGE | ORIGIN_CITY | ORIGIN_CITY_STATE | ORIGIN_COUNTRY_CODE | ORIGIN_NAME2 | ORIGIN_STATE | ORIGIN_ZIP | PROCESS_DAY_YEAR | PRO_NUMBER2 | RECEIVER | SHIPPER | SHIP_DATE | SHIP_DAY_YEAR | SHIP_WEIGHT | SOLAR_MODE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 23.06070 | 121.58442 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 1970 | LAS VEGAS | LAS VEGAS, NV | US | Melissa Bowen | NV | 89115 | 2023-10-16 | 3490944617186 | SOLAR TURBINES INC | CALTROL INC | 2023-10-05 | 2023-10-05 | 210.0 | LTL |
| 1 | 1 | 23.06070 | 121.58442 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 1970 | LAS VEGAS | LAS VEGAS, NV | US | Melissa Bowen | NV | 89115 | 2023-10-16 | 122517075583 | SOLAR TURBINES INC | CALTROL INC | 2023-10-05 | 2023-10-05 | 70.0 | LTL |
| 2 | 2 | 27.73854 | 146.27448 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 1127 | HIDALGO | HIDALGO, TX | US | Dana Hancock | TX | 78557 | 2023-10-16 | 7453824345995 | SOLAR TURBINES INC | AMETEK-PRESTOLI | 2023-10-06 | 2023-10-06 | 218.0 | LTL |
| 3 | 3 | 25.89894 | 136.55088 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 2118 | SAN DIEGO | SAN DIEGO, CA | US | Ashley Rocha | CA | 92154 | 2023-10-16 | 3661919417937 | SOLAR TURBINES INC | REXEL HOLDINGS | 2023-10-04 | 2023-10-04 | 65.0 | LTL |
| 4 | 4 | 68.28858 | 358.90596 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 2124 | CHULA VISTA | CHULA VISTA, CA | US | Jessica Huang | CA | 91914 | 2023-10-24 | 7220791461559 | SOLAR TURBINES INC | MOTION INDUSTRI | 2023-10-12 | 2023-10-12 | 775.0 | LTL |
| 5 | 5 | 133.73892 | 702.85860 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 2149 | ORANGE | ORANGE, CA | US | Lindsay French | CA | 92865 | 2023-10-24 | 3757223470581 | SOLAR TURBINES INC | BERENDSEN FLUID | 2023-10-13 | 2023-10-13 | 2120.0 | LTL |
| 6 | 6 | 25.45218 | 136.10412 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 2144 | SAN MARCOS | SAN MARCOS, CA | US | David Levy | CA | 92069 | 2023-10-25 | 5300955865408 | SOLAR TURBINES INC | WINCHESTER INTE | 2023-10-16 | 2023-10-16 | 191.0 | LTL |
| 7 | 7 | 23.32350 | 124.72488 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 1013 | ELLSWORTH | ELLSWORTH, KS | US | Linda Morales | KS | 67439 | 2023-10-25 | 6793434429403 | SOLAR TURBINES INC | CASHCO | 2023-10-16 | 2023-10-16 | 320.0 | LTL |
| 8 | 8 | 39.80106 | 212.85486 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 695 | BRIDGEVIEW | BRIDGEVIEW, IL | US | Linda Horn | IL | 60455 | 2023-10-25 | 3565251704437 | SOLAR TURBINES INC | NORMAN EQUIPMEN | 2023-10-17 | 2023-10-17 | 650.0 | LTL |
| 9 | 9 | 23.32350 | 124.75116 | Hodges, Lyons and Weaver | FAIRBURN | FAIRBURN, GA | US | Michael Clark | GA | 30213 | 1 | 903 | CEDAR FALLS | CEDAR FALLS, IA | US | Dillon White | IA | 50613 | 2023-10-25 | 1836265927986 | SOLAR TURBINES INC | VIKING PUMP | 2023-10-17 | 2023-10-17 | 70.0 | LTL |
| Unnamed: 0 | ACCESSORIAL_AMOUNT | AMOUNT_PAID | CARRIER_NAME2 | DESTINATION_CITY | DESTINATION_CITY_STATE | DESTINATION_COUNTRY_CODE | DESTINATION_NAME2 | DESTINATION_STATE | DESTINATION_ZIP | IO_CODE | MILEAGE | ORIGIN_CITY | ORIGIN_CITY_STATE | ORIGIN_COUNTRY_CODE | ORIGIN_NAME2 | ORIGIN_STATE | ORIGIN_ZIP | PROCESS_DAY_YEAR | PRO_NUMBER2 | RECEIVER | SHIPPER | SHIP_DATE | SHIP_DAY_YEAR | SHIP_WEIGHT | SOLAR_MODE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 171140 | 171140 | 60.16806 | 330.83892 | Pham LLC | CARROLLTON | CARROLLTON, TX | US | Nicole Banks | TX | 75006 | 4 | 1649 | NORTH HAVEN | NORTH HAVEN, CT | US | Brenda Drake | CT | 6473 | 2022-03-02 | 3201705855910 | AMERICAN CRATIN | SAFT AMERICA IN | 2022-02-16 | 2022-02-16 | 628.0 | LTL |
| 171141 | 171141 | 257.43888 | 1475.28036 | Pham LLC | CARSON | CARSON, CA | US | Lance Thompson | CA | 90745 | 4 | 2880 | NORTH HAVEN | NORTH HAVEN, CT | US | Brenda Drake | CT | 6473 | 2022-03-15 | 5283350332990 | CAL COAST PACKI | SAFT AMERICA IN | 2022-03-02 | 2022-03-02 | 2929.0 | LTL |
| 171142 | 171142 | 33.02082 | 163.29078 | Pham LLC | FAIRBURN | FAIRBURN, GA | US | Christopher Shepard | GA | 30213 | 4 | 995 | NORTH HAVEN | NORTH HAVEN, CT | US | Kevin Jennings | CT | 6473 | 2022-03-08 | 5031287741664 | SOLAR TURBINES | ALCAD BATTERIES | 2022-02-28 | 2022-02-28 | 95.0 | LTL |
| 171143 | 171143 | 539.43642 | 2732.27904 | Pham LLC | CARSON | CARSON, CA | US | Lance Thompson | CA | 90745 | 4 | 2880 | NORTH HAVEN | NORTH HAVEN, CT | US | Brenda Drake | CT | 6473 | 2022-03-25 | 8022334641478 | CAL COAST PACKI | SAFT AMERICA IN | 2022-03-15 | 2022-03-15 | 6066.0 | LTL |
| 171144 | 171144 | 125.80236 | 784.52370 | Pham LLC | CARROLLTON | CARROLLTON, TX | US | Nicole Banks | TX | 75006 | 4 | 1649 | NORTH HAVEN | NORTH HAVEN, CT | US | Brenda Drake | CT | 6473 | 2022-01-25 | 7056781576015 | AMERICAN CRATIN | SAFT AMERICA IN | 2022-01-10 | 2022-01-10 | 2062.0 | LTL |
| 171145 | 171145 | 43.54596 | 373.67532 | Pham LLC | ONTARIO | ONTARIO, CA | US | Christopher Shepard | CA | 91761 | 4 | 2931 | ASHLAND | ASHLAND, MA | US | Tracy Wilson | MA | 1721 | 2021-05-10 | 5614587526058 | SOLAR TURBINES | KIDDE FENWAL | 2020-06-18 | 2020-06-18 | 655.0 | LTL |
| 171146 | 171146 | 252.37998 | 2114.60706 | Pham LLC | CARSON | CARSON, CA | US | Lance Thompson | CA | 90745 | 4 | 2863 | NORTH HAVEN | NORTH HAVEN, CT | US | Brenda Drake | CT | 6473 | 2021-05-07 | 2622240063621 | CAL COAST PACKI | SAFT AMERICA IN | 2021-01-18 | 2021-01-18 | 6176.0 | LTL |
| 171147 | 171147 | 51.81102 | 367.73604 | Pham LLC | HOUSTON | HOUSTON, TX | US | Kimberly Walker | TX | 77073 | 4 | 1681 | NORTH HAVEN | NORTH HAVEN, CT | US | Brenda Drake | CT | 6473 | 2021-05-07 | 3668604150049 | SANTINI EXPORT | SAFT AMERICA IN | 2021-03-26 | 2021-03-26 | 725.0 | LTL |
| 171148 | 171148 | 25.18938 | 244.25946 | Pham LLC | SAN DIEGO | SAN DIEGO, CA | US | Christopher Shepard | CA | 92154 | 4 | 2341 | KINGS MOUNTAIN | KINGS MOUNTAIN, NC | US | Melinda Barker | NC | 28086 | 2021-05-07 | 4389720540857 | SOLAR TURBINES | PARKER HANNIFIN | 2020-09-03 | 2020-09-03 | 463.0 | LTL |
| 171149 | 171149 | 154.78920 | 509.20128 | Pham LLC | FAIRBURN | FAIRBURN, GA | US | Christopher Shepard | GA | 30213 | 4 | 995 | NORTH HAVEN | NORTH HAVEN, CT | US | Kevin Jennings | CT | 6473 | 2022-02-09 | 7530857275397 | SOLAR TURBINES | ALCAD BATTERIES | 2022-01-27 | 2022-01-27 | 491.0 | LTL |